0a ‹(ĨOBJECTIDIPARENTIDIOBJECTTYPEC OBJECTNAMEC€PROPERTYM“CODEM—RIINFOC›USERMĄ Database Database  Database TransactionLog Database StoredProceduresSource Database StoredProceduresObject Database StoredProceduresDependencies Table customers Table employees Table my company information n Table order details Table orders Table payment methods  Table payments  Table products  Table shipping methods  View sum of payments B Field orderid A Field total_payments @ View receivables aging report 6 Field shipdate 5 Field companyname 4 Field freightcharge 3 Field salestaxrate 2 Field linetotal 1 Field total_payments 0 View sales by customer ( Field customerid ' Field orderdate & Field freightcharge % Field salestaxrate # Field total_sales " Field total_units ! View sales by employee  ! Field employeeid  " Field orderdate  # Field freightcharge  $ Field salestaxrate  % Field total_sales  & Field total_units  'Field customerid G (Field companyname H )Field contactfirstname I *Field contactlastname J +Field billingaddress K ,Field city L -Field stateorprovince M .Field postalcode N /Field country O 0Field contacttitle P 1Field phonenumber Q 2Field faxnumber R 3Index postalcode U 4Index primarykey V 5Field employeeid W 6Field firstname X 7Field lastname Y 8Field title Z 9Field extension [ :Field workphone \ ;Index lastname ] <Index primarykey ^ =Field setupid _ >Field salestaxrate ` ?Field companyname a @Field address b AField city c BField stateorprovince d CField postalcode e DField country f EField phonenumber g FField faxnumber h GField defaultpaymentterms i HField defaultinvoicedescription j IIndex postalcode l JIndex primarykey m K Field orderdetailid p L Field orderid q M Field productid r N Field quantity s O Field unitprice t P Field discount u Q Index primarykey w R Field orderid { S Field customerid | T Field employeeid } U Field orderdate ~ V Field purchaseordernumber  W Field shipname € X Field shipaddress  Y Field shipcity ‚ Z Field shipstateorprovince ƒ [ Field shippostalcode „ \ Field shipcountry … ] Field shipphonenumber † ^ Field shipdate ‡ _ Field shippingmethodid ˆ ` Field freightcharge ‰ a Field salestaxrate Š b Index orderdate  c Index primarykey Ž d Index shipname  e Index shippostal ’ f Field paymentmethodid “ g Field paymentmethod ” h Field creditcard • i Index primarykey – j Field paymentid — k Field orderid ˜ l Field paymentamount ™ m Field paymentdate š n Field creditcardnumber › o Field cardholdersname œ p Field creditcardexpdate  q Field paymentmethodid ž r Index primarykey Ą s Field productid Ģ t Field productname Ī u Field unitprice Ĩ v Index primarykey Ķ wField shippingmethodid Ļ xField shippingmethod Đ yIndex primarykey Š z Index customerid Ŧ { Relation Relation 1 Ž | Index orderid ­ } Relation Relation 1 Ū ~ Index productid §  Relation Relation 2 Ē € Index orderid    Relation Relation 1 Ÿ ‚ Index employeeid ‘ ƒ Relation Relation 2  „ Index prodname Œ … Index shipmeth ‹ † Relation Relation 3 y ‡Index compname x ˆIndex lastname v ‰ Index paymeth k Š Relation Relation 2 S ‹Index compname